SELECT FROM ... WHERE INSTR(.....)

[till]

hi!

i' d like to use INSTR within my query.
i searched the web but only information is on http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_instr.  and i dont understand.

This doesnt even give me an error:

$querystring = "SELECT *  FROM $table_images".$pre_fix." WHERE   INSTR(parent_id,'TEST_50') > 1  ";

please tell me whats wrong.
thanks for helping.

till.

[Ronald Wernecke]

you should be thinking of a redesign, if you have to search for a fragment of a field.
These are the neverending queries, unless you have a different argument to cut the data down, or have small tables anyway.

but it is relatively easy:

Code:

$querystring = "SELECT *  FROM $table_images".$pre_fix." WHERE  parent_id like '%TEST_50%'";

Btw. If you think of security and performance, never do Select * - allways explicitely name the fileds you are selecting - and allways only select the fields, you want to work with, to keep response small.

[till]

Thanks ronald !

$querystring = "SELECT *  FROM $table_images".$pre_fix." WHERE   INSTR(parent_id,'TEST_50') > 0  ";

gave me the result..... (silly mistake)

but i think this over.

and how do you manage a key-word search in a longtext then ?

till.

[Ronald Wernecke]

with the LIKE operator.

The percent sign works like the asterisk in DOS/WINDOWS environment.

If you are looking for certain patterns, you should look into regular expressions.