Search for a record by number

Question

I've created two search fields.Search field 1 - Search by entering a city name (or a partial city name) - this works fine. (I am using the 'colname3' variable for this).Search field 2 - I want the user to search by number with an exact match, e.g. they enter '123456' to return record '123456' from the database.I can't seem to get this to work properly, at the moment I'm using the 'colname3' variable below which returns partial results e.g. '123' returns result '123456'.How can I modify this so the user has to enter the exact number to return the required result?This is the variable I'm using:Name:colname3Type: textDefault value: -1Runtime value: $_GET['jobnumberfield']This is the SQL statement:SELECT *FROM joinversion3WHERE job_no LIKE %colname3%

Anonymous · Answer

For exact match use = argument instead of LIKE argument. Setup conditional statement where if LIKE form is submitted then run LIKE query elseif exact match form is submitted run exact match query.

SELECT *

FROM joinversion3

WHERE job_no = $colname3

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded