Hi, I have the code below which returns all columns in mysql. How can I get it to work that it searches only in COL 3 and if found returns the content of COL 1 only?
thank you!
put "SELECT * FROM `TABLE 1` WHERE `COL 3` LIKE '%"&zoekopdit&"%'" into tSQL
put revDataFromQuery(tab, cr, gConnectionID, tSQL) into tData
put tData into field "Data"
search in mysql column 3 when found, return contents of column1 only
Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller
Re: search in mysql column 3 when found, return contents of column1 only
Hi,
if you don't want the whole record (*) but only a field (COL 1), just ask accordingly:
;-)
if you don't want the whole record (*) but only a field (COL 1), just ask accordingly:
Code: Select all
put "SELECT `COL 1` FROM `TABLE 1` WHERE `COL 3` LIKE '%" & zoekopdit & "%'" into tSQL
All code published by me here was created with Community Editions of LC (thus is GPLv3).
If you use it in closed source projects, or for the Apple AppStore, or with XCode
you'll violate some license terms - read your relevant EULAs & Licenses!
If you use it in closed source projects, or for the Apple AppStore, or with XCode
you'll violate some license terms - read your relevant EULAs & Licenses!
Re: search in mysql column 3 when found, return contents of column1 only
Exactly what I needed, thanks so much...time to learn MYSQL