version 1: SELECT max(id) id, name FROM cards WHERE name like ‘%John%’ GROUP BY name ORDER BY CASE WHEN name like ‘John %’ THEN 0 WHEN name like ‘John%’ THEN 1 WHEN name like ‘% John%’ THEN 2 ELSE 3 END, name version 2: SELECT max(id) id, name FROM cards WHERE name like ‘%John%’ GROUP … Read more
As mentioned in the comments, I would suggest what’s called the ‘compromise solution’ to anyone with a similar problem who is more concerned with not having to set weights than with making one criterion more heavily weighted than the others. Basically, you consider each of your criterion as a coordinate (after normalization, of course). Based … Read more
Create three full text indexes a) one on the keyword column b) one on the content column c) one on both keyword and content column Then, your query: SELECT id, keyword, content, MATCH (keyword) AGAINST (‘watermelon’) AS rel1, MATCH (content) AGAINST (‘watermelon’) AS rel2 FROM table WHERE MATCH (keyword,content) AGAINST (‘watermelon’) ORDER BY (rel1*1.5)+(rel2) DESC … Read more
This is a very general question but a very nice topic! Definitely upvoted 🙂 However I am not satisfied with the answers provided so far, so I decided to write a rather lengthy answer on this. The reason I am not satisfied is that the answers are basically all true (I especially like the answer … Read more
That’s simple. Use findMany: $models = Model::findMany([1, 2, 3]); By the way, you can also pass an array to find() and it will internally call findMany: $models = Model::find([1, 2, 3]); Under the hood it just does a whereIn so you could do that too: $models = Model::whereIn(‘id’, [1, 2, 3])->get();