René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Escaping natural language w/ mysql?","articleBody":"### Version\r\n\r\n1.24.0\r\n\r\n### What happened?\r\n\r\nI'm trying to do a little complicated SQL and it seems that I cannot properly escape the natural language to put in a question mark. I always only get 4 params when I should be getting 5. Does anyone know how I could escape the first so I can also have a natural language search param?\r\n\r\n### Relevant log output\r\n\r\n_No response_\r\n\r\n### Database schema\r\n\r\n```sql\r\nCREATE TABLE Profile (\r\n    id SERIAL PRIMARY KEY AUTO_INCREMENT UNIQUE,\r\n    profileOwner VARCHAR(36) NOT NULL,\r\n    name VARCHAR(512) NOT NULL,\r\n    subHead VARCHAR(512) NOT NULL,\r\n    body TEXT,\r\n    locationLat FLOAT,\r\n    locationLon FLOAT,\r\n    createdAt TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,\r\n    updatedAt TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\r\n    FOREIGN KEY (profileOwner) REFERENCES User(id) ON DELETE CASCADE,\r\n    FULLTEXT (name, body, subHead)\r\n);\r\n```\r\n\r\n### SQL queries\r\n\r\n```sql\r\nSELECT * FROM\r\n    Profile\r\nWHERE\r\n    MATCH (subHead, body, name) \r\n    AGAINST (? IN NATURAL LANGUAGE MODE)\r\n    AND locationLat BETWEEN ? AND ?\r\n    AND locationLon BETWEEN ? AND ?;\r\n```\r\n\r\n\r\n### Configuration\r\n\r\n_No response_\r\n\r\n### Playground URL\r\n\r\nhttps://play.sqlc.dev/p/69a6c4d31598994f1c63df14d1af302ab36de123d066552e2463b79653580d50\r\n\r\n### What operating system are you using?\r\n\r\nmacOS\r\n\r\n### What database engines are you using?\r\n\r\nMySQL\r\n\r\n### What type of code are you generating?\r\n\r\nGo","author":{"url":"https://github.com/JakeTrock","@type":"Person","name":"JakeTrock"},"datePublished":"2023-12-31T05:59:44.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":2},"url":"https://github.com/3091/sqlc/issues/3091"}