| Welcome to WebmasterWorld Guest from 220.127.116.11 |
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
|Explode MySql Records|
| 1:52 pm on Nov 26, 2009 (gmt 0)|
Is there a way to explode mySQL records / values while searching for records
example : SELECT * FROM tablename WHERE field = 'explode("-",field')...
I cant use the operator LIKE because the field can have records like
If I want to search for records with 10, it should only return the 1st and 3rd record.
| 4:19 pm on Nov 26, 2009 (gmt 0)|
Not that I know of. Can you use regular expressions? You should be able to substitute like for regexp though . . .
$some_var = '10';
select * from tablename where field regexp '.*$some_var.*';
select * from tablename where field regexp '.*\-$some_var\-.*';
Might have to do an "or" if it's potentially a leading or trailing:
select * from tablename where field regexp '.*\-$some_var\-.*' or field regexp '$some_var\-.*' or field regexp '.*\-$some_var';
you can also try instr() [dev.mysql.com]:
select * from tablename where instr(field,'$some_var');
Though that will match on 100 . . .
| 7:59 am on Dec 1, 2009 (gmt 0)|
RLIKE. It is LIKE but with regexp.
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
© Webmaster World 1996-2013 all rights reserved