I have 7 fields in my table and one of the field is client_id. I have 10 clients.
i want to load only data from all 7 fields of particular 5 clients.
anyone help to get it.
match(client_id, 'firstclientvalue', 'secondclientvalue') // add other 3 values, maybe remove quote
Use "where" clause:
WHERE client_id <meets some condition, or simply enumerated>
You can add the WHERE clause after the FROM clause on the script
Load * fields
Where client_id='name_client1' and client_id='name_client2' and client_id='name_client3'...
I think or
where .... or ..... or .....
Certainly it is "or". In this case, "and" will return no records at all.
And, if enumerate the values, it is cleaner with match().
yes, that's right I made a mistake while writing it down (OR shall be the correct option)
Retrieving data ...