Posts by Evanderson Pimentel • 11 points
4 posts
-
-1
votes2
answers71
viewsA: How to do WHERE with an incomplete name to find the record that in the bank is with the full name?
try: SELECT * FROM `users` WHERE `name` LIKE '%ped%'; use the % at the beginning and end of the searched text.
-
0
votes0
answers45
viewsQ: Create function within MYSQL to change data in the same table
Hello. I have an application that inserts data into a table positions, in several columns, I need to take this data work them and write a new value in the column odo, that column the application…
-
0
votes0
answers32
viewsQ: Create trigger to delete old Mysql data
Good morning. have a table "data" in this table are saved various information like 'user_id' and 'time'; I would like to create a trigger for when entering a new data delete the older than 90 days.…
-
0
votes0
answers23
viewsQ: Quick way to search first record
I’m performing the following query in Mysql: select id from positions where device_id = {$device_id} and p1 IS NOT NULL order by time desc limit 1 But the query is taking too long, because the table…