how to perform this query ??

PHPycho

Hello forums!!
Suppose i had the following table (with fields and values)
table1

-------------------------

|id | name | description |

| 1 | 12 name1 bla1 | desc1 |
| 2 | 13 name2 bla2 | desc2 |
|...so on
--------------------------

My question is: How to perform the query if i would like to fetch the row which matches the no (which is in conjuction with the name followed by space) with the passed no ie

$query  = "SELECT * FROM `table1` WHERE [no part of the name ie 12] = [passed no ie 12]";

Any suggestions , tips are warmly welcome
Thanks in advance to all of you !!

cahva

$query  = "SELECT * FROM `table1` WHERE name LIKE '12 %";

Is this what you were looking for?

kakki

you said, that "Any suggestions , tips are warmly welcome" ...
i would suggest, that u dont save more than one information in a cloumn
( in this case: devide the "name"-col into 2 columns, one containig the number and the second the
additional text ), that makes it easier to find information in the tables.
( you wont have to do a "like"-query which is slower than "="-queries