The query syntax appears to be correct. Start by inspecting the MATLAB result structure to confirm the number of rows returned by MATLAB:
disp(size(fetchedData))
If it shows duplicates (e.g., 3 rows), proceed to validate the database:
- Run the query directly in MySQL (e.g., via Workbench).
- Use a SELECT COUNT query to confirm the number of matching rows in the database.
If the database returns 1 row but MATLAB shows duplicates, the issue is not database-level. This indicates MATLAB is appending results (e.g., repeated fetch calls or code logic like loops). If both the database and MATLAB show duplicates, check for triggers using:
SHOW TRIGGERS FROM your_database;
