cheapbag214s
Joined: 27 Jun 2013
Posts: 18472
Read: 0 topics
Warns: 0/5 Location: England
|
Posted: Thu 18:25, 26 Sep 2013 Post subject: select values from tables LIKE values from another |
|
|
select values from tables LIKE values from another table,[url=http://www.duveticajacketsjp.com/][b]デュベティカ 店舗[/b][/url]
As a result i would expect one line containing id = 2,[url=http://parajumpersjakkernorgejacketkodiak.olimx.com/][b]Parajumpers Jakker Long Bear[/b][/url], username = dave and itemname = shoes because it's the only one row fulfilling my query. Unfortunately i get a message that there is no a 'desc' column. I know that there is not such column in 'users' but how tell mysql to grab it from subquery named desc?
Additional question: is that possible to work with WHERE . LIKE command and array style like IN (val1,[url=http://parajumpersjakkernorgejacketkodiak.olimx.com/][b]Parajumpers Jakker Norge[/b][/url], val2,[url=http://monclerjacketsdeutschland.albirank.net/][b]Moncler Jacken Deutschland[/b][/url], val3)? I mean instead of loooong queries:
SELECT name FROM users WHERE name LIKE "%john%" OR name LIKE "%steven%" OR name LIKE "bob%"
After hours of hopless searching correct syntax i found what i was looking for,[url=http://parajumpersoutletdanmark.albirank.net/][b]PJS Parajumpers jakker[/b][/url].
Best way,[url=http://woolrichdeutschland.albirank.net/][b]Woolrich Arctic Jacket Online[/b][/url], instead of using regexp and complicating a query i suggest using concat all column names into on string and then search it via as many LIKEs as we have keywords. Maybe that doesnt look elegant but is good enough for me. Example:
相关的主题文章:
[url=http://cgi.ebay.co.uk/ws/eBayISAPI.dll?ViewItem&item=390331089734&ssPageName=STRK:MESE:IT]http://cgi.ebay.co.uk/ws/eBayISAPI.dll?ViewItem&item=390331089734&ssPageName=STRK:MESE:IT[/url]
[url=http://cgi.www5d.biglobe.ne.jp/~riding/aska/aska.cgi/http:/https:/r-forge.r-project.org/tracker/download.php/39/219/2231/230/pr20.html%2BResult:%2Bchosen%2Bnickname%2B%2522Robidr92%2522%3B%2Bsuccess%3B]http://cgi.www5d.biglobe.ne.jp/~riding/aska/aska.cgi/http:/https:/r-forge.r-project.org/tracker/download.php/39/219/2231/230/pr20.html%2BResult:%2Bchosen%2Bnickname%2B%2522Robidr92%2522%3B%2Bsuccess%3B[/url]
[url=http://www.yaoky.com/bbs/forum.php?mod=viewthread&tid=37329]http://www.yaoky.com/bbs/forum.php?mod=viewthread&tid=37329[/url]
[url=http://www.lake-s.com/spring/bbs/spring.cgi]http://www.lake-s.com/spring/bbs/spring.cgi[/url]
[url=http://www.azsns.com/home.php?mod=spacecp&ac=blog&blogid=]http://www.azsns.com/home.php?mod=spacecp&ac=blog&blogid=[/url]
[url=http://www.mybaina.com/bbs/forum.php?mod=viewthread&tid=274201&extra=]http://www.mybaina.com/bbs/forum.php?mod=viewthread&tid=274201&extra=[/url]
[url=http://www.sfsite.com/fsf/blog/forum/topic.php?id=1506098]http://www.sfsite.com/fsf/blog/forum/topic.php?id=1506098[/url]
[url=http://fitnesswerx.com.au/ads/quality-wooden-backgammon-sets-available-from-bell-2/]http://fitnesswerx.com.au/ads/quality-wooden-backgammon-sets-available-from-bell-2/[/url]
[url=http://cgi.ebay.ca/ws/eBayISAPI.dll?ViewItem&item=321008881654&ssPageName=STRK:MESE:IT]http://cgi.ebay.ca/ws/eBayISAPI.dll?ViewItem&item=321008881654&ssPageName=STRK:MESE:IT[/url]
[url=http://www.surin3.net/main/index.php?option=com_blog&view=blog]http://www.surin3.net/main/index.php?option=com_blog&view=blog[/url]
The post has been approved 0 times
|
|