Executing query: SELECT id, firstname, lastname, email, gender, agerange, comments, regdate, is_active FROM users WHERE comments LIKE '%comment%'
The number of retrieved records is: 4
ID | First Name | Last Name | Gender | Age Range | Comments | Registration Date | Active | |
---|---|---|---|---|---|---|---|---|
1 | John | Doe | johndoe@example.com | Male | 18-25 | No comments | 2024-10-21 01:32:14 | 1 |
2 | Jane | Smith | janesmith@example.com | Female | 26-35 | Test comment | 2024-10-21 01:32:14 | 1 |
6 | Akshar | Patel | aksharpatel@example.com | Male | 18-25 | Yes comments | 2024-10-21 01:37:41 | 1 |
7 | Bob | Smith | bobsmith@example.com | Male | 26-35 | comment!! | 2024-10-21 01:37:41 | 1 |
Search finished.