Search found 2 matches
- Tue Mar 12, 2019 9:56 pm
- Forum: Getting Started with LiveCode - Complete Beginners
- Topic: search in mysql column 3 when found, return contents of column1 only
- Replies: 2
- Views: 2270
Re: search in mysql column 3 when found, return contents of column1 only
Exactly what I needed, thanks so much...time to learn MYSQL
- Tue Mar 12, 2019 7:49 am
- Forum: Getting Started with LiveCode - Complete Beginners
- Topic: search in mysql column 3 when found, return contents of column1 only
- Replies: 2
- Views: 2270
search in mysql column 3 when found, return contents of column1 only
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, t...