Dear list,
I have a telephone database which has "Name" as one of the fields/columns.
This field contains single name e.g Robert, double names e.g Robert
Downing and more than double names. I want to make a SELECT query using a
form whose input name is "Name" i.e '$Name' against the "Name" field in the
database. One can type a part/full of one part of the name, or part/full of
two parts of a name and goes on likewise for more than double names in the
input form.
I believe this SELECT query is accomplished using TRIM and LIKE, something
like:
$query = ("SELECT * from table_name where Name like '%" & Trim($Name) & "%'
");
This $query is not working.
Could sombody please provide me a query statement that I could use for my
above requirement.
Thank you so much.
NOBBY
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
