Tag: mysql

MySQL 9's native VECTOR data type lets PHP developers build semantic search and AI similarity features without spinning up a separate vector database.

Recursive CTEs in MySQL let you query trees, org charts, and nested categories in a single query. Here's how to use them effectively with PHP.

JSON columns in MySQL are powerful but misunderstood. Here's a practical guide for PHP developers on when JSON makes sense, how to query it efficiently, and the indexing tricks that keep things fast.