na primafista malko :>
mysql> select table1.id, table1.id2,table1.id3, concat( table1.data1, table2.data2, table3.data3) as searchString from table1,table2,table3 where concat( table1.data1, table2.data2, table3.data3) like '%33%' and table1.id=3 and table2.id=table1.id2 and table3.id=table1.id3;
+----+-----+-----+--------------------+
| id | id2 | id3 | searchString |
+----+-----+-----+--------------------+
| 3 | 3 | 3 | data13data23data33 |
+----+-----+-----+--------------------+
1 row in set (0.00 sec)
mysql> select table1.id, table1.id2,table1.id3, concat( table1.data1, table2.data2, table3.data3) as searchString from table1,table2,table3 where concat( table1.data1, table2.data2, table3.data3) like '%23%' and table1.id=3 and table2.id=table1.id2 and table3.id=table1.id3;
+----+-----+-----+--------------------+
| id | id2 | id3 | searchString |
+----+-----+-----+--------------------+
| 3 | 3 | 3 | data13data23data33 |
+----+-----+-----+--------------------+
1 row in set (0.01 sec)mysql> select table1.id, table1.id2,table1.id3, concat( table1.data1, table2.data2, table3.data3) as searchString from table1,table2,table3 where concat( table1.data1, table2.data2, table3.data3) like '%23%' and table1.id=2 and table2.id=table1.id2 and table3.id=table1.id3;
Empty set (0.01 sec)
mysql> select table1.id, table1.id2,table1.id3, concat( table1.data1, table2.data2, table3.data3) as searchString from table1,table2,table3 where concat( table1.data1, table2.data2, table3.data3) like '%data12%' and table1.id=2 and table2.id=table1.id2 and table3.id=table1.id3;
+----+-----+-----+--------------------+
| id | id2 | id3 | searchString |
+----+-----+-----+--------------------+
| 2 | 2 | 2 | data12data22data32 |
+----+-----+-----+--------------------+
1 row in set (0.00 sec)
predpolagam 4e salle sha kae po-dobyr na4in za tfa :>
like '%string-looking-for%' e string koito tyrsis
table1.id=id-to-na-table1-za-koeto-tyrsis
rgdz
curly
|