| id |
first name |
last name |
email |
password |
regDate |
SELECT * FROM users WHERE firstName LIKE 'J%'
The total number of retrieved rows is 4
| 3 | Julie | Smith | juliesmith@gmail.com | afa45c67f1b4f2f9f76ff0f5bf941bc72fff280fb5f4913e4fd45217fc307e88 | 2025-03-08 01:37:33 |
| 4 | John | Doe | johndoe@gmail.com | afa45c67f1b4f2f9f76ff0f5bf941bc72fff280fb5f4913e4fd45217fc307e88 | 2025-03-08 01:37:33 |
| 5 | Jane | Doe | janesmith@gmail.com | afa45c67f1b4f2f9f76ff0f5bf941bc72fff280fb5f4913e4fd45217fc307e88 | 2025-03-08 01:37:33 |
| 6 | Joe | Swanson | joeswanson@gmail.com | 1370c2f1a856b7a5f779233206e23a9f11b04aa35bf35fed1c6526be2036ae4e | 2025-03-08 01:43:31 |